class CreateMerchant < ActiveRecord::Migration
  def change
    create_table :merchants do |t|
      t.string :name
      t.string :phone
      t.string :business_scope
      t.string :merchant_type
      t.string :longitude
      t.string :latitude
      t.string :location
      t.boolean :is_dtd, default: false
      t.string :service_start
      t.string :service_end
      t.string :information_clerk_id
      
      t.timestamps null: false
    end

    add_index :merchants, :created_at
    add_index :merchants, :information_clerk_id
    add_index :merchants, :merchant_type
    add_index :merchants, :is_dtd
  end
end
